Columns

Grants

Dependencies

Details

Triggers

Errors


COLUMN_NAME DATA_TYPE NULLABLE DATA_DEFAULT COLUMN_ID COMMENTS INSERTABLE UPDATABLE DELETABLE
INVOLV_SID NUMBER(38) No null 12 null NO NO NO
IS_PRI_SUBJECT VARCHAR2(1) Yes null 13 null NO NO NO
OBJ VARCHAR2(20) No null 1 null NO NO NO
PARTIC_OBJ VARCHAR2(20) No null 2 null NO NO NO
USAGE VARCHAR2(100) No null 3 null NO NO NO
CODE VARCHAR2(50) No null 4 null NO NO NO
ROLE_DISPLAY VARCHAR2(100) No null 5 null NO NO NO
ROLE_ACTIVE VARCHAR2(1) No null 6 null NO NO NO
PARTIC_DISPLAY VARCHAR2(400) Yes null 7 null NO NO NO
PARTIC_OBJ_TYPE_CODE VARCHAR2(51) No null 8 null NO NO NO
PARTIC_OBJ_TYPE_DISP VARCHAR2(100) No null 9 null NO NO NO
PARTICIPANT_NAME VARCHAR2(400) Yes null 10 null NO NO NO
OFFICE VARCHAR2(4000) Yes null 11 null NO NO NO
PRIVILEGE GRANTEE GRANTABLE GRANTOR OBJECT_NAME
OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE
QART V_SIII_COLL_INVESTIGATIONS VIEW QART V_OBJ_PARTICIPANTS VIEW
QART V_SIII_INVESTIGATIONS VIEW QART V_OBJ_PARTICIPANTS VIEW
QART V_SIIC_INTAKE VIEW QART V_OBJ_PARTICIPANTS VIEW
QART V_CUBE_INTERCOM_ALL VIEW QART V_OBJ_PARTICIPANTS VIEW
QART V_CUBE_SIII_INVESTIGATIONS VIEW QART V_OBJ_PARTICIPANTS VIEW
QART V_ALL_ALLEGATIONS VIEW QART V_OBJ_PARTICIPANTS VIEW
QART V_SIIC_THREAT_INV VIEW QART V_OBJ_PARTICIPANTS VIEW
QART MV_ALL_ALLEGATIONS MATERIALIZED VIEW QART V_OBJ_PARTICIPANTS VIEW
QART V_CUBE_TIMES_INVESTIGATIONS VIEW QART V_OBJ_PARTICIPANTS VIEW



References


OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE
QART V_OBJ_PARTICIPANTS VIEW QART MV_ACM_OBJ TABLE
QART V_OBJ_PARTICIPANTS VIEW QART MV_ACM_OBJ_TYPE TABLE
QART V_OBJ_PARTICIPANTS VIEW QART MV_PARTIC_INDIV_OFFICE TABLE
QART V_OBJ_PARTICIPANTS VIEW QART MV_PARTIC_INDIV_OFFICE_REF TABLE
QART V_OBJ_PARTICIPANTS VIEW QART MV_PARTIC_ROLE_TYPE TABLE
QART V_OBJ_PARTICIPANTS VIEW QART MV_PARTIC_INVOLVEMENT TABLE
OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE
QART V_OBJ_PARTICIPANTS VIEW QART MV_ACM_OBJ TABLE
QART V_OBJ_PARTICIPANTS VIEW QART MV_ACM_OBJ_TYPE TABLE
QART V_OBJ_PARTICIPANTS VIEW QART MV_PARTIC_INDIV_OFFICE TABLE
QART V_OBJ_PARTICIPANTS VIEW QART MV_PARTIC_INDIV_OFFICE_REF TABLE
QART V_OBJ_PARTICIPANTS VIEW QART MV_PARTIC_ROLE_TYPE TABLE
QART V_OBJ_PARTICIPANTS VIEW QART MV_PARTIC_INVOLVEMENT TABLE
OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE
QART V_OBJ_PARTICIPANTS VIEW QART MV_ACM_OBJ TABLE
QART V_OBJ_PARTICIPANTS VIEW QART MV_ACM_OBJ_TYPE TABLE
QART V_OBJ_PARTICIPANTS VIEW QART MV_PARTIC_INDIV_OFFICE TABLE
QART V_OBJ_PARTICIPANTS VIEW QART MV_PARTIC_INDIV_OFFICE_REF TABLE
QART V_OBJ_PARTICIPANTS VIEW QART MV_PARTIC_ROLE_TYPE TABLE
QART V_OBJ_PARTICIPANTS VIEW QART MV_PARTIC_INVOLVEMENT TABLE
OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE
QART V_OBJ_PARTICIPANTS VIEW QART MV_ACM_OBJ TABLE
QART V_OBJ_PARTICIPANTS VIEW QART MV_ACM_OBJ_TYPE TABLE
QART V_OBJ_PARTICIPANTS VIEW QART MV_PARTIC_INDIV_OFFICE TABLE
QART V_OBJ_PARTICIPANTS VIEW QART MV_PARTIC_INDIV_OFFICE_REF TABLE
QART V_OBJ_PARTICIPANTS VIEW QART MV_PARTIC_ROLE_TYPE TABLE
QART V_OBJ_PARTICIPANTS VIEW QART MV_PARTIC_INVOLVEMENT TABLE
OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE
QART V_OBJ_PARTICIPANTS VIEW QART MV_ACM_OBJ TABLE
QART V_OBJ_PARTICIPANTS VIEW QART MV_ACM_OBJ_TYPE TABLE
QART V_OBJ_PARTICIPANTS VIEW QART MV_PARTIC_INDIV_OFFICE TABLE
QART V_OBJ_PARTICIPANTS VIEW QART MV_PARTIC_INDIV_OFFICE_REF TABLE
QART V_OBJ_PARTICIPANTS VIEW QART MV_PARTIC_ROLE_TYPE TABLE
QART V_OBJ_PARTICIPANTS VIEW QART MV_PARTIC_INVOLVEMENT TABLE
OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE
QART V_OBJ_PARTICIPANTS VIEW QART MV_ACM_OBJ TABLE
QART V_OBJ_PARTICIPANTS VIEW QART MV_ACM_OBJ_TYPE TABLE
QART V_OBJ_PARTICIPANTS VIEW QART MV_PARTIC_INDIV_OFFICE TABLE
QART V_OBJ_PARTICIPANTS VIEW QART MV_PARTIC_INDIV_OFFICE_REF TABLE
QART V_OBJ_PARTICIPANTS VIEW QART MV_PARTIC_ROLE_TYPE TABLE
QART V_OBJ_PARTICIPANTS VIEW QART MV_PARTIC_INVOLVEMENT TABLE
OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE
QART V_OBJ_PARTICIPANTS VIEW QART MV_ACM_OBJ TABLE
QART V_OBJ_PARTICIPANTS VIEW QART MV_ACM_OBJ_TYPE TABLE
QART V_OBJ_PARTICIPANTS VIEW QART MV_PARTIC_INDIV_OFFICE TABLE
QART V_OBJ_PARTICIPANTS VIEW QART MV_PARTIC_INDIV_OFFICE_REF TABLE
QART V_OBJ_PARTICIPANTS VIEW QART MV_PARTIC_ROLE_TYPE TABLE
QART V_OBJ_PARTICIPANTS VIEW QART MV_PARTIC_INVOLVEMENT TABLE
OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE
QART V_OBJ_PARTICIPANTS VIEW QART MV_ACM_OBJ TABLE
QART V_OBJ_PARTICIPANTS VIEW QART MV_ACM_OBJ_TYPE TABLE
QART V_OBJ_PARTICIPANTS VIEW QART MV_PARTIC_INDIV_OFFICE TABLE
QART V_OBJ_PARTICIPANTS VIEW QART MV_PARTIC_INDIV_OFFICE_REF TABLE
QART V_OBJ_PARTICIPANTS VIEW QART MV_PARTIC_ROLE_TYPE TABLE
QART V_OBJ_PARTICIPANTS VIEW QART MV_PARTIC_INVOLVEMENT TABLE
OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE
QART V_OBJ_PARTICIPANTS VIEW QART MV_ACM_OBJ TABLE
QART V_OBJ_PARTICIPANTS VIEW QART MV_ACM_OBJ_TYPE TABLE
QART V_OBJ_PARTICIPANTS VIEW QART MV_PARTIC_INDIV_OFFICE TABLE
QART V_OBJ_PARTICIPANTS VIEW QART MV_PARTIC_INDIV_OFFICE_REF TABLE
QART V_OBJ_PARTICIPANTS VIEW QART MV_PARTIC_ROLE_TYPE TABLE
QART V_OBJ_PARTICIPANTS VIEW QART MV_PARTIC_INVOLVEMENT TABLE
NAME VALUE
CREATED 10-APR-23
LAST_DDL_TIME 05-FEB-25
OWNER QART
VIEW_NAME V_OBJ_PARTICIPANTS
TEXT_LENGTH 744
TEXT SELECT I.OBJ,           I.PARTICIPANT PARTIC_OBJ,           T.USAGE,           T.CODE,           T.DISPLAY ROLE_DISPLAY,           T.ACTIVE ROLE_ACTIVE,           O.TAGLINE PARTIC_DISPLAY,           OT.OBJ_TYPE_CODE PARTIC_OBJ_TYPE_CODE,           OT.DISPLAY PARTIC_OBJ_TYPE_DISP,           O.TAGLINE PARTICIPANT_NAME,   TPIOR.DISPLAY OFFICE,   I.SID INVOLV_SID,   I.IS_PRI_SUBJECT      FROM MV_PARTIC_INVOLVEMENT I     INNER JOIN MV_PARTIC_ROLE_TYPE T ON I.INVOLVEMENT_ROLE = T.SID     INNER JOIN MV_ACM_OBJ O ON I.PARTICIPANT = O.SID     INNER JOIN MV_ACM_OBJ_TYPE OT ON O.OBJ_TYPE = OT.SID LEFT JOIN MV_PARTIC_INDIV_OFFICE TPIO ON TPIO.SID = I.INDIV_OFFICE     LEFT JOIN MV_PARTIC_INDIV_OFFICE_REF TPIOR ON TPIOR.REF_KEY = TPIO.OFFICE
TEXT_VC SELECT I.OBJ,           I.PARTICIPANT PARTIC_OBJ,           T.USAGE,           T.CODE,           T.DISPLAY ROLE_DISPLAY,           T.ACTIVE ROLE_ACTIVE,           O.TAGLINE PARTIC_DISPLAY,           OT.OBJ_TYPE_CODE PARTIC_OBJ_TYPE_CODE,           OT.DISPLAY PARTIC_OBJ_TYPE_DISP,           O.TAGLINE PARTICIPANT_NAME,   TPIOR.DISPLAY OFFICE,   I.SID INVOLV_SID,   I.IS_PRI_SUBJECT      FROM MV_PARTIC_INVOLVEMENT I     INNER JOIN MV_PARTIC_ROLE_TYPE T ON I.INVOLVEMENT_ROLE = T.SID     INNER JOIN MV_ACM_OBJ O ON I.PARTICIPANT = O.SID     INNER JOIN MV_ACM_OBJ_TYPE OT ON O.OBJ_TYPE = OT.SID LEFT JOIN MV_PARTIC_INDIV_OFFICE TPIO ON TPIO.SID = I.INDIV_OFFICE     LEFT JOIN MV_PARTIC_INDIV_OFFICE_REF TPIOR ON TPIOR.REF_KEY = TPIO.OFFICE
TYPE_TEXT_LENGTH null
TYPE_TEXT null
OID_TEXT_LENGTH null
OID_TEXT null
VIEW_TYPE_OWNER null
VIEW_TYPE null
SUPERVIEW_NAME null
EDITIONING_VIEW N
READ_ONLY N
CONTAINER_DATA N
BEQUEATH DEFINER
ORIGIN_CON_ID 16
DEFAULT_COLLATION USING_NLS_COMP
CONTAINERS_DEFAULT NO
CONTAINER_MAP NO
EXTENDED_DATA_LINK NO
EXTENDED_DATA_LINK_MAP NO
HAS_SENSITIVE_COLUMN NO
ADMIT_NULL NO
PDB_LOCAL_ONLY NO
DUPLICATED N
SHARDED N
OWNER TRIGGER_NAME TRIGGER_TYPE TRIGGERING_EVENT STATUS OBJECT_ID




ATTRIBUTE Line:Position TEXT